<!DOCTYPE html>
<html lang="zh-CN">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width,initial-scale=1">
    <title>快速上手 | Luckysheet文档</title>
    <meta name="generator" content="VuePress 1.8.0">
    
    <meta name="description" content="Luckysheet ，一款纯前端类似excel的在线表格，功能强大、配置简单、完全开源。本站包含官方配置文档,API,教程。">
    <meta property="article:modified_time" content="2021-01-19T01:33:53.000Z">
    <meta property="og:title" content="快速上手">
    <meta property="og:type" content="website">
    <meta property="og:url" content="https://mengshukeji.github.io/LuckysheetDemo/zh/guide/">
    <meta name="twitter:title" content="快速上手">
    <meta name="twitter:url" content="https://mengshukeji.github.io/LuckysheetDemo/zh/guide/">
    <meta name="twitter:card" content="summary_large_image">
    <meta name="twitter:label1" content="Written by">
    
    <link rel="preload" href="/LuckysheetDocs/assets/css/0.styles.58462003.css" as="style"><link rel="preload" href="/LuckysheetDocs/assets/js/app.02d9598d.js" as="script"><link rel="preload" href="/LuckysheetDocs/assets/js/2.daa13025.js" as="script"><link rel="preload" href="/LuckysheetDocs/assets/js/26.e74f90a6.js" as="script"><link rel="prefetch" href="/LuckysheetDocs/assets/js/10.866635ea.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/11.825eabba.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/12.980dcb91.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/13.119fa3a0.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/14.61ea2478.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/15.51a43d85.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/16.de626d16.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/17.e9ae302c.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/18.46d5e5a0.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/19.6ab6bd88.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/20.a4dd0048.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/21.cf5034d8.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/22.c45a4387.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/23.e08fd533.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/24.d1e4369b.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/25.291afc50.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/27.1142ecb7.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/28.d6d28da0.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/29.1ae5f953.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/3.c428902d.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/30.bf70d4f4.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/31.d87cf3af.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/32.a1b6f5f4.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/33.eded6080.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/4.b5e0f872.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/5.e526f9d4.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/6.8106d72b.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/7.c0fe87fd.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/8.abc5c19b.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/9.2bf3882a.js">
    <link rel="stylesheet" href="/LuckysheetDocs/assets/css/0.styles.58462003.css">
  </head>
  <body>
    <div id="app" data-server-rendered="true"><div class="theme-container"><header class="navbar"><div class="sidebar-button"><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" role="img" viewBox="0 0 448 512" class="icon"><path fill="currentColor" d="M436 124H12c-6.627 0-12-5.373-12-12V80c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12z"></path></svg></div> <a href="/LuckysheetDocs/zh/" class="home-link router-link-active"><img src="/LuckysheetDocs/img/logo.png" alt="Luckysheet文档" class="logo"> <span class="site-name can-hide">Luckysheet文档</span></a> <div class="links"><div class="search-box"><input aria-label="Search" autocomplete="off" spellcheck="false" value=""> <!----></div> <nav class="nav-links can-hide"><div class="nav-item"><a href="/LuckysheetDocs/zh/" class="nav-link">
  首页
</a></div><div class="nav-item"><a href="/LuckysheetDocs/zh/guide/" aria-current="page" class="nav-link router-link-exact-active router-link-active">
  指南
</a></div><div class="nav-item"><a href="https://mengshukeji.github.io/LuckysheetDemo/" target="_blank" rel="noopener noreferrer" class="nav-link external">
  演示
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="了解更多" class="dropdown-title"><span class="title">了解更多</span> <span class="arrow down"></span></button> <button type="button" aria-label="了解更多" class="mobile-dropdown-title"><span class="title">了解更多</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/zh/about/" class="nav-link">
  关于
</a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="选择语言" class="dropdown-title"><span class="title">选择语言</span> <span class="arrow down"></span></button> <button type="button" aria-label="选择语言" class="mobile-dropdown-title"><span class="title">选择语言</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/guide/" class="nav-link">
  English
</a></li><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/zh/guide/" aria-current="page" class="nav-link router-link-exact-active router-link-active">
  简体中文
</a></li></ul></div></div> <a href="https://github.com/mengshukeji/Luckysheet" target="_blank" rel="noopener noreferrer" class="repo-link">
    GitHub
    <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></nav></div></header> <div class="sidebar-mask"></div> <aside class="sidebar"><nav class="nav-links"><div class="nav-item"><a href="/LuckysheetDocs/zh/" class="nav-link">
  首页
</a></div><div class="nav-item"><a href="/LuckysheetDocs/zh/guide/" aria-current="page" class="nav-link router-link-exact-active router-link-active">
  指南
</a></div><div class="nav-item"><a href="https://mengshukeji.github.io/LuckysheetDemo/" target="_blank" rel="noopener noreferrer" class="nav-link external">
  演示
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="了解更多" class="dropdown-title"><span class="title">了解更多</span> <span class="arrow down"></span></button> <button type="button" aria-label="了解更多" class="mobile-dropdown-title"><span class="title">了解更多</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/zh/about/" class="nav-link">
  关于
</a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="选择语言" class="dropdown-title"><span class="title">选择语言</span> <span class="arrow down"></span></button> <button type="button" aria-label="选择语言" class="mobile-dropdown-title"><span class="title">选择语言</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/guide/" class="nav-link">
  English
</a></li><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/zh/guide/" aria-current="page" class="nav-link router-link-exact-active router-link-active">
  简体中文
</a></li></ul></div></div> <a href="https://github.com/mengshukeji/Luckysheet" target="_blank" rel="noopener noreferrer" class="repo-link">
    GitHub
    <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></nav>  <ul class="sidebar-links"><li><a href="/LuckysheetDocs/zh/guide/" aria-current="page" class="active sidebar-link">快速上手</a><ul class="sidebar-sub-headers"><li class="sidebar-sub-header"><a href="/LuckysheetDocs/zh/guide/#基本介绍" class="sidebar-link">基本介绍</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/zh/guide/#demo" class="sidebar-link">Demo</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/zh/guide/#在线案例" class="sidebar-link">在线案例</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/zh/guide/#特性" class="sidebar-link">特性</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/zh/guide/#开发模式" class="sidebar-link">开发模式</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/zh/guide/#使用步骤" class="sidebar-link">使用步骤</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/zh/guide/#整体结构" class="sidebar-link">整体结构</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/zh/guide/#快捷键" class="sidebar-link">快捷键</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/zh/guide/#指引" class="sidebar-link">指引</a></li></ul></li><li><a href="/LuckysheetDocs/zh/guide/config.html" class="sidebar-link">整体配置</a></li><li><a href="/LuckysheetDocs/zh/guide/sheet.html" class="sidebar-link">工作表配置</a></li><li><a href="/LuckysheetDocs/zh/guide/cell.html" class="sidebar-link">单元格</a></li><li><a href="/LuckysheetDocs/zh/guide/operate.html" class="sidebar-link">表格操作</a></li><li><a href="/LuckysheetDocs/zh/guide/api.html" class="sidebar-link">API</a></li><li><a href="/LuckysheetDocs/zh/guide/resource.html" class="sidebar-link">教程与资源</a></li><li><a href="/LuckysheetDocs/zh/guide/FAQ.html" class="sidebar-link">常见问题</a></li><li><a href="/LuckysheetDocs/zh/guide/contribute.html" class="sidebar-link">贡献指南</a></li></ul> </aside> <main class="page"> <div class="theme-default-content content__default"><h1 id="快速上手"><a href="#快速上手" class="header-anchor">#</a> 快速上手</h1> <h2 id="基本介绍"><a href="#基本介绍" class="header-anchor">#</a> 基本介绍</h2> <p>Luckysheet ，一款纯前端类似excel的在线表格，功能强大、配置简单、完全开源。</p> <h2 id="demo"><a href="#demo" class="header-anchor">#</a> Demo</h2> <p><a href="https://mengshukeji.github.io/LuckysheetDemo/" target="_blank" rel="noopener noreferrer">在线demo<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></p> <p><img src="/LuckysheetDocs/img/LuckysheetDemo.gif" alt="演示"></p> <h2 id="在线案例"><a href="#在线案例" class="header-anchor">#</a> 在线案例</h2> <ul><li><a href="http://luckysheet.lashuju.com/demo/" target="_blank" rel="noopener noreferrer">协同编辑Demo<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li></ul> <h2 id="特性"><a href="#特性" class="header-anchor">#</a> 特性</h2> <h3 id="🛠️格式设置"><a href="#🛠️格式设置" class="header-anchor">#</a> 🛠️格式设置</h3> <ul><li><strong>样式</strong> (修改字体样式，字号，颜色或者其他通用的样式)</li> <li><strong>条件格式</strong> (突出显示所关注的单元格或单元格区域；强调异常值；使用数据栏、色阶和图标集（与数据中的特定变体对应）直观地显示数据)</li> <li><strong>文本对齐及旋转</strong></li> <li><strong>支持文本的截断、溢出、自动换行</strong></li> <li><strong>数据类型</strong> <ul><li><strong>货币, 百分比, 数字, 日期</strong></li> <li><strong>Custom</strong> (和excel保持一致，例如： <code>##,###0.00</code> , <code>$1,234.56$##,###0.00_);[Red]($##,###0.00)</code>, <code>_($* ##,###0.00_);_(...($* &quot;-&quot;_);_(@_)</code>, <code>08-05 PM 01:30MM-dd AM/PM hh:mm</code> )</li></ul></li> <li><strong>单元格内多样式</strong> (Alt+Enter单元格内换行、上标、下标、单元格内可定义每个文字的不同样式)</li></ul> <h3 id="🧬单元格"><a href="#🧬单元格" class="header-anchor">#</a> 🧬单元格</h3> <ul><li><strong>拖拽选取来修改单元格</strong> (对选区进行操作，可以拖动四边来移动选区，也可以在右下角对选区进行下拉填充操作)</li> <li><strong>选区下拉填充</strong> (对于一个1,2,3,4,5的序列，将会按照间隔为1进行下拉填充，而对2,4,6,8将会以2作为间隔。支持等差数列，等比数列，日期，周，天，月，年，中文数字填充)</li> <li><strong>自动填充选项</strong> (下拉填充后，会出现填充选项的菜单，支持选择复制，序列，仅格式，只填充格式，天，月，年的选择)</li> <li><strong>多选区操作</strong> (可以按住Ctrl键进行单元格多选操作，支持多选区的复制粘贴)</li> <li><strong>查找和替换</strong> (对内容进行查找替换，支持正则表达式，整词，大小写敏感)</li> <li><strong>定位</strong> (可以根据单元格的数据类型进行自动定位并选中，选中后可以批量进行格式等操作)</li> <li><strong>合并单元格</strong></li> <li><strong>数据验证(表单功能)</strong>  (支持Checkbox, drop-down list, datePicker)</li></ul> <h3 id="🖱️行和列操作"><a href="#🖱️行和列操作" class="header-anchor">#</a> 🖱️行和列操作</h3> <ul><li><strong>隐藏，插入，删除行或列</strong></li> <li><strong>冻结行或列</strong> (支持冻结首行和首列，冻结到选区，冻结调节杆可以进行拖动操作)</li> <li><strong>文本分列</strong> (可以把文本根据不同符号进行拆分，和excel的分列功能类似)</li></ul> <h3 id="🔨操作体验"><a href="#🔨操作体验" class="header-anchor">#</a> 🔨操作体验</h3> <ul><li><strong>撤销/重做</strong></li> <li><strong>复制/粘贴/剪切操作</strong> (支持Luckysheet到excel和excel到Luckysheet带格式的互相拷贝)</li> <li><strong>快捷键支持</strong> (快捷键操作保持与excel一致，如果有不同或者缺失请反馈给我们)</li> <li><strong>格式刷</strong> (与google sheet类似)</li> <li><strong>任意选区拖拽</strong> (选择单元格，输入公式，插入图表，会与选区相关，可以通过任意拖动和放大缩小选区来改变与之关联的参数)</li></ul> <h3 id="⚙️公式和函数"><a href="#⚙️公式和函数" class="header-anchor">#</a> ⚙️公式和函数</h3> <ul><li><strong>内置公式</strong> <ul><li>数学 (SUMIFS, AVERAGEIFS, SUMIF, SUM, etc.)</li> <li>文本 (CONCATENATE, REGEXMATCH, MID)</li> <li>日期 (DATEVALUE, DATEDIF, NOW, WEEKDAY, etc.)</li> <li>财务 (PV, FV, IRR, NPV, etc.)</li> <li>逻辑 (IF, AND, OR, IFERROR, etc.)</li> <li>查找和引用 (VLOOKUP, HLOOkUP, INDIRECT, OFFSET, etc.)</li> <li>动态数组 (Excel2019新函数，SORT,FILTER,UNIQUE,RANDARRAY,SEQUENCE)</li></ul></li> <li><strong>公式支持数组</strong> (={1,2,3,4,5,6}, Crtl+Shift+Enter)</li> <li><strong>远程公式</strong> (DM_TEXT_TFIDF, DM_TEXT_TEXTRANK,DATA_CN_STOCK_CLOSE etc. Need remote interface, can realize complex calculation)</li> <li><strong>自定义公式</strong>  (根据身份证识别年龄，性别，生日，省份，城市等. AGE_BY_IDCARD, SEX_BY_IDCARD, BIRTHDAY_BY_IDCARD, PROVINCE_BY_IDCARD, CITY_BY_IDCARD, etc. 可以任意加入自己的公式哦)</li></ul> <h3 id="📐表格操作"><a href="#📐表格操作" class="header-anchor">#</a> 📐表格操作</h3> <ul><li><strong>筛选</strong> (支持颜色、数字、字符、日期的筛选)</li> <li><strong>排序</strong> (同时加入多个字段进行排序)</li></ul> <h3 id="📈数据透视表"><a href="#📈数据透视表" class="header-anchor">#</a> 📈数据透视表</h3> <ul><li><strong>字段拖拽</strong> (操作方式与excel类似，拖动字段到行、列、数值、筛选等4个区域)</li> <li><strong>聚合方式</strong>  (支持汇总、计数、去重计数、平均、最大、最小、中位数、协方差、标准差、方差等计算)</li> <li><strong>筛选数据</strong> (可对字段进行筛选后再进行汇总)</li> <li><strong>数据透视表下钻</strong> (双击数据透视表中的数据，可以下钻查看到明细，操作方式与excel一致)</li> <li><strong>根据数据透视表新建图表</strong> (数据透视表产生的数据也可以进行图表的制作)</li></ul> <h3 id="📊图表"><a href="#📊图表" class="header-anchor">#</a> 📊图表</h3> <ul><li><strong>支持的图表类型</strong> (目前折线图、柱状图、面积图、条形图、饼图可以使用，散点图、雷达图、仪表盘、漏斗图正在接入，其他图表正在陆续开发中，请大家给予建议)</li> <li><strong>关于图表插件</strong>  (图表使用了一个中间插件<a href="https://github.com/mengshukeji/chartMix" target="_blank" rel="noopener noreferrer">ChartMix<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a>(MIT协议): 目前支持ECharts，正在逐步接入Highcharts、阿里G2、amCharts、googleChart、chart.js)</li> <li><strong>Sparklines小图</strong> (以公式的形式进行设置和展示，目前支持：折线图、面积图、柱状图、累积图、条形图、离散图、三态图、饼图、箱线图等)</li></ul> <h3 id="✍️分享及写作"><a href="#✍️分享及写作" class="header-anchor">#</a> ✍️分享及写作</h3> <ul><li><strong>评论</strong> (评论的删除、添加、修改、隐藏)</li> <li><strong>共享编辑</strong> (支持多用户共享编辑，内置API)</li></ul> <h3 id="📚插入对象"><a href="#📚插入对象" class="header-anchor">#</a> 📚插入对象</h3> <ul><li><strong>插入图片</strong> (支持JPG,PNG,SVG的插入、修改和删除，并且随表格的变动而产生变化)</li></ul> <h3 id="⚡luckysheet专有"><a href="#⚡luckysheet专有" class="header-anchor">#</a> ⚡Luckysheet专有</h3> <ul><li><strong>矩阵计算</strong> (通过右键菜单进行支持：对选区内的数据进行转置、旋转、数值计算)</li> <li><strong>截图</strong> (把选区的内容进行截图展示)</li> <li><strong>复制到其他格式</strong> (右键菜单的&quot;复制为&quot;, 支持复制为json、array、对角线数据、去重等)</li> <li><strong>EXCEL导入及导出</strong> (专为Luckysheet打造的导入导出插件，支持密码、水印、公式等的本地导入导出，导出正在开发)</li></ul> <h3 id="⏱️未来开发计划"><a href="#⏱️未来开发计划" class="header-anchor">#</a> ⏱️未来开发计划</h3> <ul><li><strong>打印及设置</strong> (像excel一样进行打印设置，并导出为图片或者PDF)</li> <li><strong>树形菜单</strong> (类似excel中的分级显示（分组）)</li> <li><strong>表格新功能</strong> (类似excel中表格的筛选器和切片器)</li> <li><strong>CSV,TXT导入及导出</strong> (专为Luckysheet打造的导入导出插件，支持密码、水印、公式等的本地导入导出)</li> <li><strong>插入svg形状</strong> (支持<a href="https://github.com/mengshukeji/Pentool" target="_blank" rel="noopener noreferrer">Pen tool<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a>的插入、修改和删除，并且随表格的变动而产生变化)</li> <li><strong>文档</strong> (完善文档和API)</li> <li><strong>敬请期待...</strong> (可以提出好的建议给我们)</li></ul> <h2 id="开发模式"><a href="#开发模式" class="header-anchor">#</a> 开发模式</h2> <h3 id="环境"><a href="#环境" class="header-anchor">#</a> 环境</h3> <p><a href="https://nodejs.org/en/" target="_blank" rel="noopener noreferrer">Node.js<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a> Version &gt;= 6</p> <h3 id="安装"><a href="#安装" class="header-anchor">#</a> 安装</h3> <div class="language-shell extra-class"><pre class="language-shell"><code><span class="token function">npm</span> <span class="token function">install</span>
<span class="token function">npm</span> <span class="token function">install</span> gulp -g
</code></pre></div><h3 id="开发"><a href="#开发" class="header-anchor">#</a> 开发</h3> <div class="language-shell extra-class"><pre class="language-shell"><code><span class="token function">npm</span> run dev
</code></pre></div><h3 id="打包"><a href="#打包" class="header-anchor">#</a> 打包</h3> <div class="language-shell extra-class"><pre class="language-shell"><code><span class="token function">npm</span> run build
</code></pre></div><h2 id="使用步骤"><a href="#使用步骤" class="header-anchor">#</a> 使用步骤</h2> <h3 id="第一步"><a href="#第一步" class="header-anchor">#</a> 第一步</h3> <p>引入依赖，有2种方式</p> <h4 id="cdn"><a href="#cdn" class="header-anchor">#</a> CDN</h4> <div class="language-html extra-class"><pre class="language-html"><code><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>link</span> <span class="token attr-name">rel</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>stylesheet<span class="token punctuation">'</span></span> <span class="token attr-name">href</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>https://cdn.jsdelivr.net/npm/luckysheet/dist/plugins/css/pluginsCss.css<span class="token punctuation">'</span></span> <span class="token punctuation">/&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>link</span> <span class="token attr-name">rel</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>stylesheet<span class="token punctuation">'</span></span> <span class="token attr-name">href</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>https://cdn.jsdelivr.net/npm/luckysheet/dist/plugins/plugins.css<span class="token punctuation">'</span></span> <span class="token punctuation">/&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>link</span> <span class="token attr-name">rel</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>stylesheet<span class="token punctuation">'</span></span> <span class="token attr-name">href</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>https://cdn.jsdelivr.net/npm/luckysheet/dist/css/luckysheet.css<span class="token punctuation">'</span></span> <span class="token punctuation">/&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>link</span> <span class="token attr-name">rel</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>stylesheet<span class="token punctuation">'</span></span> <span class="token attr-name">href</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>https://cdn.jsdelivr.net/npm/luckysheet/dist/assets/iconfont/iconfont.css<span class="token punctuation">'</span></span> <span class="token punctuation">/&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>script</span> <span class="token attr-name">src</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">&quot;</span>https://cdn.jsdelivr.net/npm/luckysheet/dist/plugins/js/plugin.js<span class="token punctuation">&quot;</span></span><span class="token punctuation">&gt;</span></span><span class="token script"></span><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;/</span>script</span><span class="token punctuation">&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>script</span> <span class="token attr-name">src</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">&quot;</span>https://cdn.jsdelivr.net/npm/luckysheet/dist/luckysheet.umd.js<span class="token punctuation">&quot;</span></span><span class="token punctuation">&gt;</span></span><span class="token script"></span><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;/</span>script</span><span class="token punctuation">&gt;</span></span>
</code></pre></div><p>注意，<code>https://cdn.jsdelivr.net/npm/luckysheet/dist/luckysheet.umd.js</code>这个路径意思是会拉取到最新的luckysheet代码，但是如果Luckysheet刚刚发布，jsdelivr网站可能还没来得及从npm上同步过去，故而使用这个路径还是会拉到上一个版本，我们推荐您直接指定最新版本。</p> <p>想要指定Luckysheet版本，请在所有的CDN依赖文件后面加上版本号，如：<code>https://cdn.jsdelivr.net/npm/luckysheet@2.1.12/dist/luckysheet.umd.js</code>。</p> <blockquote><p>如何知道最新版本是哪一版？查看最新 <a href="https://github.com/mengshukeji/Luckysheet/releases" target="_blank" rel="noopener noreferrer">release记录<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a> 或者 <a href="https://github.com/mengshukeji/Luckysheet/blob/master/package.json" target="_blank" rel="noopener noreferrer">package.json<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a> 的<code>version</code>字段。</p></blockquote> <p>如果不方便访问 jsdelivr.net，还可以采用本地方式引入</p> <h4 id="本地引入"><a href="#本地引入" class="header-anchor">#</a> 本地引入</h4> <p><code>npm run build</code>后<code>dist</code>文件夹下的所有文件复制到项目目录，然后通过相对路径引入</p> <div class="language-html extra-class"><pre class="language-html"><code><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>link</span> <span class="token attr-name">rel</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>stylesheet<span class="token punctuation">'</span></span> <span class="token attr-name">href</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>./plugins/css/pluginsCss.css<span class="token punctuation">'</span></span> <span class="token punctuation">/&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>link</span> <span class="token attr-name">rel</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>stylesheet<span class="token punctuation">'</span></span> <span class="token attr-name">href</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>./plugins/plugins.css<span class="token punctuation">'</span></span> <span class="token punctuation">/&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>link</span> <span class="token attr-name">rel</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>stylesheet<span class="token punctuation">'</span></span> <span class="token attr-name">href</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>./css/luckysheet.css<span class="token punctuation">'</span></span> <span class="token punctuation">/&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>link</span> <span class="token attr-name">rel</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>stylesheet<span class="token punctuation">'</span></span> <span class="token attr-name">href</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>./assets/iconfont/iconfont.css<span class="token punctuation">'</span></span> <span class="token punctuation">/&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>script</span> <span class="token attr-name">src</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">&quot;</span>./plugins/js/plugin.js<span class="token punctuation">&quot;</span></span><span class="token punctuation">&gt;</span></span><span class="token script"></span><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;/</span>script</span><span class="token punctuation">&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>script</span> <span class="token attr-name">src</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">&quot;</span>./luckysheet.umd.js<span class="token punctuation">&quot;</span></span><span class="token punctuation">&gt;</span></span><span class="token script"></span><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;/</span>script</span><span class="token punctuation">&gt;</span></span>
</code></pre></div><h3 id="第二步"><a href="#第二步" class="header-anchor">#</a> 第二步</h3> <p>指定一个表格容器</p> <div class="language-html extra-class"><pre class="language-html"><code><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>div</span> <span class="token attr-name">id</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">&quot;</span>luckysheet<span class="token punctuation">&quot;</span></span> <span class="token style-attr"><span class="token attr-name">style</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">&quot;</span><span class="token style language-css"><span class="token property">margin</span><span class="token punctuation">:</span>0px<span class="token punctuation">;</span><span class="token property">padding</span><span class="token punctuation">:</span>0px<span class="token punctuation">;</span><span class="token property">position</span><span class="token punctuation">:</span>absolute<span class="token punctuation">;</span><span class="token property">width</span><span class="token punctuation">:</span>100%<span class="token punctuation">;</span><span class="token property">height</span><span class="token punctuation">:</span>100%<span class="token punctuation">;</span><span class="token property">left</span><span class="token punctuation">:</span> 0px<span class="token punctuation">;</span><span class="token property">top</span><span class="token punctuation">:</span> 0px<span class="token punctuation">;</span></span><span class="token punctuation">&quot;</span></span></span><span class="token punctuation">&gt;</span></span><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;/</span>div</span><span class="token punctuation">&gt;</span></span>
</code></pre></div><h3 id="第三步"><a href="#第三步" class="header-anchor">#</a> 第三步</h3> <p>创建一个表格</p> <div class="language-javascript extra-class"><pre class="language-javascript"><code><span class="token operator">&lt;</span>script<span class="token operator">&gt;</span>
    <span class="token function">$</span><span class="token punctuation">(</span><span class="token keyword">function</span> <span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
        <span class="token comment">//配置项</span>
        <span class="token keyword">var</span> options <span class="token operator">=</span> <span class="token punctuation">{</span>
            container<span class="token operator">:</span> <span class="token string">'luckysheet'</span> <span class="token comment">//luckysheet为容器id</span>
        <span class="token punctuation">}</span>
        luckysheet<span class="token punctuation">.</span><span class="token function">create</span><span class="token punctuation">(</span>options<span class="token punctuation">)</span>
    <span class="token punctuation">}</span><span class="token punctuation">)</span>
<span class="token operator">&lt;</span><span class="token operator">/</span>script<span class="token operator">&gt;</span>
</code></pre></div><h2 id="整体结构"><a href="#整体结构" class="header-anchor">#</a> 整体结构</h2> <h3 id="格式"><a href="#格式" class="header-anchor">#</a> 格式</h3> <p>一个完整的Luckysheet表格文件的数据格式为：luckysheetfile，一个表格文件包含若干个sheet文件，对应excel的sheet0、sheet1等。</p> <p>一个Luckysheet文件的示例如下，该表格包含3个sheet：<code>luckysheetfile = [ {sheet1设置}, {sheet2设置}, {sheet3设置} ]</code>
相当于excel的3个sheet</p> <p><img src="/LuckysheetDocs/img/excel.png" alt="excel sheet"></p> <p>文件中的一个sheet的数据<code>luckysheetfile[0]</code>的结构如下：</p> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
	<span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Cell&quot;</span><span class="token punctuation">,</span> <span class="token comment">//工作表名称</span>
	<span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span> <span class="token comment">//工作表颜色</span>
	<span class="token property">&quot;index&quot;</span><span class="token operator">:</span> <span class="token string">&quot;0&quot;</span><span class="token punctuation">,</span> <span class="token comment">//工作表索引</span>
	<span class="token property">&quot;status&quot;</span><span class="token operator">:</span> <span class="token string">&quot;1&quot;</span><span class="token punctuation">,</span> <span class="token comment">//激活状态</span>
	<span class="token property">&quot;order&quot;</span><span class="token operator">:</span> <span class="token string">&quot;0&quot;</span><span class="token punctuation">,</span> <span class="token comment">//工作表的顺序</span>
	<span class="token property">&quot;hide&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span><span class="token comment">//是否隐藏</span>
	<span class="token property">&quot;row&quot;</span><span class="token operator">:</span> <span class="token number">36</span><span class="token punctuation">,</span> <span class="token comment">//行数</span>
	<span class="token property">&quot;column&quot;</span><span class="token operator">:</span> <span class="token number">18</span><span class="token punctuation">,</span> <span class="token comment">//列数</span>
	<span class="token property">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
		<span class="token property">&quot;merge&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//合并单元格</span>
		<span class="token property">&quot;rowlen&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//表格行高</span>
		<span class="token property">&quot;columnlen&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//表格列宽</span>
		<span class="token property">&quot;rowhidden&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//隐藏行</span>
		<span class="token property">&quot;colhidden&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//隐藏列</span>
		<span class="token property">&quot;borderInfo&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//边框</span>
	<span class="token punctuation">}</span><span class="token punctuation">,</span>
	<span class="token property">&quot;celldata&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//初始化使用的单元格数据</span>
	<span class="token property">&quot;data&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//更新和存储使用的单元格数据</span>
	<span class="token property">&quot;scrollLeft&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//左右滚动条位置</span>
	<span class="token property">&quot;scrollTop&quot;</span><span class="token operator">:</span> <span class="token number">315</span><span class="token punctuation">,</span> <span class="token comment">//上下滚动条位置</span>
	<span class="token property">&quot;luckysheet_select_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//选中的区域</span>
	<span class="token property">&quot;luckysheet_conditionformat_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//条件格式</span>
	<span class="token property">&quot;calcChain&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span><span class="token comment">//公式链</span>
	<span class="token property">&quot;isPivotTable&quot;</span><span class="token operator">:</span><span class="token boolean">false</span><span class="token punctuation">,</span><span class="token comment">//是否数据透视表</span>
	<span class="token property">&quot;pivotTable&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//数据透视表设置</span>
	<span class="token property">&quot;filter_select&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//筛选范围</span>
	<span class="token property">&quot;filter&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span><span class="token comment">//筛选配置</span>
	<span class="token property">&quot;luckysheet_alternateformat_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//交替颜色</span>
	<span class="token property">&quot;luckysheet_alternateformat_save_modelCustom&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//自定义交替颜色	</span>
	<span class="token property">&quot;freezen&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//冻结行列</span>
	<span class="token property">&quot;chart&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//图表配置</span>
	<span class="token property">&quot;visibledatarow&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//所有行的位置</span>
	<span class="token property">&quot;visibledatacolumn&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//所有列的位置</span>
	<span class="token property">&quot;ch_width&quot;</span><span class="token operator">:</span> <span class="token number">2322</span><span class="token punctuation">,</span> <span class="token comment">//工作表区域的宽度</span>
	<span class="token property">&quot;rh_height&quot;</span><span class="token operator">:</span> <span class="token number">949</span><span class="token punctuation">,</span> <span class="token comment">//工作表区域的高度</span>
	<span class="token property">&quot;load&quot;</span><span class="token operator">:</span> <span class="token string">&quot;1&quot;</span><span class="token punctuation">,</span> <span class="token comment">//已加载过此sheet的标识</span>
<span class="token punctuation">}</span>
</code></pre></div><h3 id="查看方式"><a href="#查看方式" class="header-anchor">#</a> 查看方式</h3> <p>在chrome的console中查看
<code>luckysheet.getluckysheetfile()</code>
可以看到完整设置
<code>[{shee1}, {sheet2}, {sheet3}]</code></p> <h2 id="快捷键"><a href="#快捷键" class="header-anchor">#</a> 快捷键</h2> <table><thead><tr><th>快捷键</th> <th>功能</th></tr></thead> <tbody><tr><td>CTRL + C</td> <td>复制单元格</td></tr> <tr><td>CTRL + V</td> <td>粘贴单元格</td></tr> <tr><td>CTRL + X</td> <td>剪切单元格</td></tr> <tr><td>CTRL + Z</td> <td>撤销</td></tr> <tr><td>CTRL + Y</td> <td>重做</td></tr> <tr><td>CTRL + A</td> <td>全选</td></tr> <tr><td>CTRL + B</td> <td>加粗</td></tr> <tr><td>CTRL + F</td> <td>查找</td></tr> <tr><td>CTRL + H</td> <td>替换</td></tr> <tr><td>CTRL + I</td> <td>斜体</td></tr> <tr><td>CTRL + UP/DOWN/LEFT/RIGHT</td> <td>快捷调整单元格选框</td></tr> <tr><td>SHIFT + UP/DOWN/LEFT/RIGHT</td> <td>调整选区</td></tr> <tr><td>CTRL + 鼠标左击</td> <td>多选单元格</td></tr> <tr><td>SHIFT + 鼠标左击</td> <td>调整选区</td></tr> <tr><td>UP/DOWN/LEFT/RIGHT</td> <td>移动单元格选框</td></tr> <tr><td>ENTER</td> <td>编辑单元格</td></tr> <tr><td>TAB</td> <td>向右移动单元格选框</td></tr> <tr><td>DELETE</td> <td>清除单元格数据</td></tr></tbody></table> <h2 id="指引"><a href="#指引" class="header-anchor">#</a> 指引</h2> <p>如果您使用Luckysheet遇到了问题，按以下步骤来寻找答案</p> <ol><li>使用多吉或者Google搜索常见技术问题</li> <li>Luckysheet相关的问题优先查看<a href="https://mengshukeji.github.io/LuckysheetDocs/zh/" target="_blank" rel="noopener noreferrer">Luckysheet官方文档<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a>（注意标注TODO的功能暂未实现）</li> <li>搜索<a href="https://mengshukeji.github.io/LuckysheetDocs/zh/guide/FAQ.html" target="_blank" rel="noopener noreferrer">常见问题列表<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li> <li>搜索<a href="https://support.qq.com/product/288322" target="_blank" rel="noopener noreferrer">官方论坛<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a>，看看有没有人已经遇到过</li> <li>尝试自己检查或试验以找到答案</li> <li>请尝试阅读源代码以找到答案，</li></ol> <p>如果以上方法都没有解决您的问题，可以考虑：</p> <ul><li>去<a href="https://support.qq.com/product/288322" target="_blank" rel="noopener noreferrer">官方论坛<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a>提问</li> <li>去Luckysheet官方微信群或者QQ群提问</li> <li>发现有明显问题的或者需求无法满足的，直接提交<a href="https://github.com/mengshukeji/Luckysheet/issues" target="_blank" rel="noopener noreferrer">issues<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li></ul> <blockquote><p>推荐阅读 <a href="https://github.com/ryanhanwu/How-To-Ask-Questions-The-Smart-Way/blob/master/README-zh_CN.md" target="_blank" rel="noopener noreferrer">提问的智慧<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></p></blockquote> <p>同时，我们强烈推荐您帮助我们丰富Luckysheet社区</p> <ul><li>如果您发现文档或者代码有问题，您可以通过提交PR来贡献。所有合理的改动、优化、修正，或者文档的修正、更新相关的提交都会被接受</li> <li>当您有了一部分使用或者二次开发Luckysheet的经验，我们鼓励您通过博文分享出来</li></ul></div> <footer class="page-edit"><div class="edit-link"><a href="https://github.com/mengshukeji/Luckysheet/edit/master/docs/zh/guide/README.md" target="_blank" rel="noopener noreferrer">在 GitHub 上编辑此页</a> <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></div> <div class="last-updated"><span class="prefix">上次更新:</span> <span class="time">1/19/2021, 1:33:53 AM</span></div></footer> <div class="page-nav"><p class="inner"><!----> <span class="next"><a href="/LuckysheetDocs/zh/guide/config.html">
        整体配置
      </a>
      →
    </span></p></div> </main></div><div class="global-ui"></div></div>
    <script src="/LuckysheetDocs/assets/js/app.02d9598d.js" defer></script><script src="/LuckysheetDocs/assets/js/2.daa13025.js" defer></script><script src="/LuckysheetDocs/assets/js/26.e74f90a6.js" defer></script>
  </body>
</html>
